<?xml version="1.0" encoding="utf-8"?>
<!-- BaseSchema.xml - The Microsoft Learning Components (MLC) base schema -->
<StoreSchema xmlns="urn:schemas-microsoft-com:learning-components:learning-store-schema">
<Enum Name="AudioCaptioning">
<Values>
<Value Name="Off" Value="-1" />
<Value Name="NoChange" Value="0" />
<Value Name="On" Value="1" />
</Values>
</Enum>
<Enum Name="CompletionStatus">
<Values>
<Value Name="Unknown" Value="0" />
<Value Name="Completed" Value="1" />
<Value Name="Incomplete" Value="2" />
<Value Name="NotAttempted" Value="3" />
</Values>
</Enum>
<Enum Name="ExitMode">
<Values>
<Value Name="Undetermined" Value="0" />
<Value Name="Logout" Value="1" />
<Value Name="Normal" Value="2" />
<Value Name="TimeOut" Value="3" />
<Value Name="Suspended" Value="4" />
</Values>
</Enum>
<Enum Name="DisplayMode">
<Values>
<Value Name="Normal" Value="0" />
<Value Name="Browse" Value="1" />
<Value Name="Review" Value="2" />
</Values>
</Enum>
<Enum Name="SuccessStatus">
<Values>
<Value Name="Unknown" Value="0" />
<Value Name="Failed" Value="1" />
<Value Name="Passed" Value="2" />
</Values>
</Enum>
<Enum Name="TimeLimitAction">
<Values>
<Value Name="ContinueNoMessage" Value="0" />
<Value Name="ContinueWithMessage" Value="1" />
<Value Name="ExitNoMessage" Value="2" />
<Value Name="ExitWithMessage" Value="3" />
</Values>
</Enum>
<Enum Name="InteractionType">
<Values>
<Value Name="Other" Value="0" />
<Value Name="FillIn" Value="1" />
<Value Name="Likert" Value="2" />
<Value Name="LongFillIn" Value="3" />
<Value Name="Matching" Value="4" />
<Value Name="MultipleChoice" Value="5" />
<Value Name="Numeric" Value="6" />
<Value Name="Performance" Value="7" />
<Value Name="Sequencing" Value="8" />
<Value Name="TrueFalse" Value="9" />
<Value Name="Essay" Value="10" />
<Value Name="Attachment" Value="11" />
</Values>
</Enum>
<Enum Name="InteractionResultState">
<Values>
<Value Name="None" Value="0" />
<Value Name="Correct" Value="1" />
<Value Name="Incorrect" Value="2" />
<Value Name="Neutral" Value="3" />
<Value Name="Numeric" Value="4" />
<Value Name="Unanticipated" Value="5" />
</Values>
</Enum>
<Enum Name="PackageFormat">
<Values>
<Value Name="Lrm" Value="0" />
<Value Name="V1p2" Value="1" />
<Value Name="V1p3" Value="2" />
</Values>
</Enum>
<Enum Name="LessonStatus">
<Values>
<Value Name="NotAttempted" Value="0" />
<Value Name="Browsed" Value="1" />
<Value Name="Completed" Value="2" />
<Value Name="Failed" Value="3" />
<Value Name="Incomplete" Value="4" />
<Value Name="Passed" Value="5" />
</Values>
</Enum>
<Enum Name="NavigationCommand">
<Values>
<Value Name="None" Value="0" />
<Value Name="Abandon" Value="1" />
<Value Name="AbandonAll" Value="2" />
<Value Name="ChoiceStart" Value="3" />
<Value Name="Choose" Value="4" />
<Value Name="Continue" Value="5" />
<Value Name="ExitAll" Value="6" />
<Value Name="Previous" Value="7" />
<Value Name="ResumeAll" Value="8" />
<Value Name="Start" Value="9" />
<Value Name="SuspendAll" Value="10" />
<Value Name="UnqualifiedExit" Value="11" />
</Values>
</Enum>
<Enum Name="SequencingEventType">
<Values>
<Value Name="FinalNavigation" Value="0" />
<Value Name="IntermediateNavigation" Value="1" />
<Value Name="Rollup" Value="2" />
</Values>
</Enum>
<Enum Name="AttemptStatus">
<Values>
<Value Name="Active" Value="0" />
<Value Name="Abandoned" Value="1" />
<Value Name="Completed" Value="2" />
<Value Name="Suspended" Value="3" />
</Values>
</Enum>
<ItemType Name="ActivityAttemptItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about one <a href="SlkConcepts.htm#Packages">activity</a> in the context of one <a href="SlkConcepts.htm#Assignments">attempt</a>.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>AttemptId is the identifier for the attempt on the package.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ActivityPackageId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>ActivityPackageId is the identifier for the activity information that is contained in the package.</para>
</Summary>
</Documentation>
</Property>
<Property Name="CompletionStatus" Type="Enum" EnumName="CompletionStatus">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>CompletionStatus indicates whether or not the activity has been completed.</para>
</Summary>
</Documentation>
</Property>
<Property Name="AttemptCount" Type="Int32" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>AttemptCount is a count of the number of sessions this attempt has taken. Every time the attempt is suspended and resumed, this is updated.</para>
</Summary>
</Documentation>
</Property>
<Property Name="DataModelCache" Type="Xml" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>DataModelCache is an XML representation of the dynamic data not required for sequencing relating to this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="EvaluationPoints" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>EvaluationPoints is the point value assigned by an instructor as an evaluation of learner responses.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Exit" Type="Enum" EnumName="ExitMode" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Exit indicates how or why a user left the activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="LessonStatus" Type="Enum" EnumName="LessonStatus" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>LessonStatus indicates the status of the attempt. This value is only used in SCORM 1.2.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Location" Type="String" Length="1000" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Location is the information used by the SCO to determine the learner's position within the SCO, similar in concept to a bookmark.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MinScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>MinScore is the minimum score allowed.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MaxScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>MaxScore is the maximum score allowed.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ProgressMeasure" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ProgressMeasure is the progress toward completing the activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="RandomPlacement" Type="Int32" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>RandomPlacement is the order assigned to this activity relative to its siblings. This information is most useful when the cluster is to be randomized.</para>
</Summary>
</Documentation>
</Property>
<Property Name="RawScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>RawScore is the score that reflects the performance of the learner, between MinScore and MaxScore.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ScaledScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ScaledScore is the score that reflects the performance of the learner.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SequencingDataCache" Type="Xml" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>SequencingDataCache is an XML representation of the dynamic data required for sequencing relating to this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SessionStartTimestamp" Type="DateTime" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>SessionStartTimestamp is the time (UTC) that the current session started.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SessionTime" Type="Double" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>SessionTime is the duration of the session as determined by SCO.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>SuccessStatus indicates whether the learner has mastered the SCO.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SuspendData" Type="String" Nullable="true" Length="4096">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>SuspendData is the data saved by SCO when the attempt on the activity is suspended.</para>
</Summary>
</Documentation>
</Property>
<Property Name="TotalTime" Type="Double" Nullable="true">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>TotalTime is the time (in seconds) spent on previous sessions in this attempt on an activity.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX AttemptIndex
ON ActivityAttemptItem(AttemptId)
</Index>
<Index>
CREATE INDEX ActivityPackageIndex
ON ActivityAttemptItem(ActivityPackageId, AttemptId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="ActivityObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about one <a href="SlkConcepts.htm#ScormConcepts">local objective</a> of
one <a href="SlkConcepts.htm#Packages">activity</a> within one e-learning package.
Objectives that are added to a package by a
<a href="SlkConcepts.htm#Packages">SCO</a> via the
<a href="SlkConcepts.htm#ScormConcepts">RTE</a> are not included in this table.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="ActivityPackageId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>ActivityPackageId is the identifier for the activity related to this objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="IsPrimaryObjective" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>If IsPrimaryObjective is true, this is the primary objective for the related activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Key" Type="String" Nullable="true" Length="4096">
<Documentation>
<Summary xmlns="">
<para>Key is the identifier from the manifest that identifies this objective. Not necessarily unique.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MinNormalizedMeasure" Type="Single">
<Default>1</Default>
<Documentation>
<Summary xmlns="">
<para>MinNormalizedMeasure is the minimum measure required to satisfy the measure.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SatisfiedByMeasure" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>SatisfiedByMeasure is the TODO.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX ActivityPackageIndex
ON ActivityObjectiveItem(ActivityPackageId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about one <a href="SlkConcepts.htm#Packages">activity</a>
within one e-learning package.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="ActivityIdFromManifest" Type="String" Length="4096">
<Documentation>
<Summary xmlns="">
<para>ActivityIdFromManifest is the identifier for this attempt from the manifest. Guaranteed unique within a package, not unique in the table.</para>
</Summary>
</Documentation>
</Property>
<Property Name="OriginalPlacement" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>OriginalPlacement is the order assigned to the activity relative to its siblings based on the appearance of the activity in the manifest. The value is zero-based.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ParentActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ParentActivityId is the identifier of the activity that is a parent of this activity in the activity tree of an organization. If null, this is the root activity being attempted.</para>
</Summary>
</Documentation>
</Property>
<Property Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>PackageId is the identifier of the package associated with this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="PrimaryObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityObjectiveItem" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>PrimaryObjectiveId is the identifier of the objective which is identified as the primary objective for this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ResourceId" Type="ItemIdentifier" ReferencedItemTypeName="ResourceItem" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ResourceId is the identifier of the resource information for this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="PrimaryResourceFromManifest" Type="String" Length="2000" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>PrimaryResourceFromManifest is the primary resource to launch for an attempt on this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="DataModelCache" Type="Xml" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>DataModelCache is an XML representation of the static data relating to this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="CompletionThreshold" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>CompletionThreshold is the completion threshold (as defined in RTE) for this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Credit" Type="Boolean" Nullable="true">
<Default>true</Default>
<Documentation>
<Summary xmlns="">
<para>Credit indicates whether the learner will be credited for completion of the activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="HideContinue" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>HideContinue is the flag indicating the UI should not display the 'Continue' button.</para>
</Summary>
</Documentation>
</Property>
<Property Name="HidePrevious" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>HidePrevious is the flag indicating the UI should not display the 'Previous' button.</para>
</Summary>
</Documentation>
</Property>
<Property Name="HideExit" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>HideExit is the flag indicating the UI should not display the 'Exit' button.</para>
</Summary>
</Documentation>
</Property>
<Property Name="HideAbandon" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>HideAbandon is the flag indicating the UI should not display the 'Abandon' button.</para>
</Summary>
</Documentation>
</Property>
<Property Name="IsVisibleInContents" Type="Boolean">
<Default>true</Default>
<Documentation>
<Summary xmlns="">
<para>If IsVisibleInContents is true, the activity is eligible to be visible in the table of contents.</para>
</Summary>
</Documentation>
</Property>
<Property Name="LaunchData" Type="String" Nullable="true" Length="4096">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>LaunchData is the data provided to start an activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MasteryScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>MasteryScore is the 'passing' score in SCORM 1.2 content.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MaxAttempts" Type="Int32" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>MaxAttempts is the maximum number of attempts allowed on this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MaxTimeAllowed" Type="Double" Nullable="true">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>MaxTimeAllowed is the maximum time allowed for the user to complete a single attempt on the activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ResourceParameters" Type="String" Length="1000" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ResourceParameters is the parameter string used in conjunction with the primary resource for this activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ScaledPassingScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ScaledPassingScore is the passing score required to 'pass' the SCO.</para>
</Summary>
</Documentation>
</Property>
<Property Name="TimeLimitAction" Type="Enum" EnumName="TimeLimitAction" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>TimeLimitAction indicates what a SCO should do when time limit is exceeded.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Title" Type="String" Length="200">
<Documentation>
<Summary xmlns="">
<para>Title is the title of the activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ObjectivesGlobalToSystem" Type="Boolean">
<Default>true</Default>
<Documentation>
<Summary xmlns="">
<para>ObjectivesGlobalToSystem is the flag indicating whether the global objectives referenced in this activity tree are global for the learner and the content organization (false) or global for the lifetime of the learner(true).</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX PackageIndex
ON ActivityPackageItem(PackageId)
</Index>
<Index>
CREATE INDEX ParentActivityIndex
ON ActivityPackageItem(ParentActivityId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="PackageGlobalObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about progress on one
<a href="SlkConcepts.htm#ScormConcepts">global objective</a> related to one
<a href="SlkConcepts.htm#Assignments">organization</a>.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>LearnerId is the identifier of the learner related to this entry.</para>
</Summary>
</Documentation>
</Property>
<Property Name="GlobalObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="GlobalObjectiveItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>GlobalObjectiveId is the identifier for the objective related to this entry.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ScaledScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ScaledScore is the score that reflects the performance of the learner on this objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>SuccessStatus indicates whether or not the learner has successfully met this objective.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX GlobalObjectiveIndex
ON PackageGlobalObjectiveItem(GlobalObjectiveId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="AttemptItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about one <a href="SlkConcepts.htm#Assignments">attempt</a>, i.e. one
instance of one learner executing one
<a href="SlkConcepts.htm#Packages">organization</a> of one e-learning package.
If the same learner attempts the same organization twice, two AttemptItem rows are
created.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>. SLK <a href="SlkSchema.xml.htm">extends</a> this item type by adding the
<a href="Microsoft.SharePointLearningKit.Schema.AttemptItem.LearnerAssignmentId.Field.htm">LearnerAssignmentId</a> property/column and a SQL index.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>LearnerId is the identifier of the learner of this attempt.</para>
</Summary>
</Documentation>
</Property>
<Property Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem">
<Documentation>
<Summary xmlns="">
<para>RootActivityId is the identifier of the root activity of the package.</para>
</Summary>
</Documentation>
</Property>
<Property Name="CompletionStatus" Type="Enum" EnumName="CompletionStatus">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>CompletionStatus is the TODO.</para>
</Summary>
</Documentation>
</Property>
<Property Name="CurrentActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>CurrentActivityId is the identifier of the current active activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SuspendedActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>SuspendedActivityId is the identifier of the previously suspended activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem">
<Documentation>
<Summary xmlns="">
<para>PackageId is the identifier of the package that is being attempted.</para>
</Summary>
</Documentation>
</Property>
<Property Name="AttemptStatus" Type="Enum" EnumName="AttemptStatus">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>AttemptStatus is the status of the attempt.</para>
</Summary>
</Documentation>
</Property>
<Property Name="FinishedTimestamp" Type="DateTime" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>FinishedTimestamp is the date/time (UTC) the attempt was completed or abandoned.</para>
</Summary>
</Documentation>
</Property>
<Property Name="LogDetailSequencing" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>If LogDetailSequencing is true, details of navigation are logged, from the initial activity up to but not including the final destination.</para>
</Summary>
</Documentation>
</Property>
<Property Name="LogFinalSequencing" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>If LogFinalSequencing is true, final destination arrived at when navigating is logged.</para>
</Summary>
</Documentation>
</Property>
<Property Name="LogRollup" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>If LogRollup is true, rollup operations are logged.</para>
</Summary>
</Documentation>
</Property>
<Property Name="StartedTimestamp" Type="DateTime" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>StartedTimestamp is the date/time (UTC) when the attempt was started.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>SuccessStatus is the TODO.</para>
</Summary>
</Documentation>
</Property>
<Property Name="TotalPoints" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>TotalPoints is the TODO.</para>
</Summary>
</Documentation>
</Property>
</Properties>
</ItemType>
<ItemType Name="AttemptObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about the learner's progress on one
<a href="SlkConcepts.htm#ScormConcepts">local objective</a> for one
<a href="SlkConcepts.htm#Packages">activity</a> of one
<a href="SlkConcepts.htm#Assignments">attempt</a>.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="ActivityAttemptId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>ActivityAttemptId is the identifier of the activity related to this attempt.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ActivityObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityObjectiveItem" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ActivityObjectiveId is the identifier for the objective related to this entry.</para>
</Summary>
</Documentation>
</Property>
<Property Name="CompletionStatus" Type="Enum" EnumName="CompletionStatus">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>CompletionStatus indicates whether or not the learner has completed work on this objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Description" Type="String" Length="255" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Description is the description of the objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="IsPrimaryObjective" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>If IsPrimaryObjective is true, then this is the primary objective for the related activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Key" Type="String" Nullable="true" Length="4096">
<Documentation>
<Summary xmlns="">
<para>Key is the identifier for the activity. The identifier is not necessarily unique.</para>
</Summary>
</Documentation>
</Property>
<Property Name="LessonStatus" Type="Enum" EnumName="LessonStatus" Nullable="true">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>LessonStatus is the SCORM 1.2 compliance field to include status of the current user with respect to this objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="RawScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>RawScore is the score that reflects the performance of the learner on this objective, between MinScore and MaxScore.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MinScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>MinScore is the minimum score allowed on this objective for the learner.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MaxScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>MaxScore is the maximum score allowed on this objective for this learner.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ProgressMeasure" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ProgressMeasure is the progress of learner in completing this objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ScaledScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ScaledScore is the score that reflects the performance of the learner on this objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>SuccessStatus indicates whether or not the learner has successfully met this objective.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX ActivityAttemptIndex
ON AttemptObjectiveItem(ActivityAttemptId, ActivityObjectiveId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="CommentFromLearnerItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains one comment from the learner related to one
<a href="SlkConcepts.htm#Packages">activity</a> of one
<a href="SlkConcepts.htm#Assignments">attempt</a>.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="ActivityAttemptId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>ActivityAttemptId is the identifier for the attempt on the activity related to this comment.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Comment" Type="String" Length="4096">
<Documentation>
<Summary xmlns="">
<para>Comment is the text of the comment.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Location" Type="String" Length="255" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>Location is the text indicating where the comment applies.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Ordinal" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>Ordinal is the TODO.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Timestamp" Type="String" Length="28" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>Timestamp is the timestamp (UTC) indicating when the comment was created or most recently changed.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX ActivityAttemptIndex
ON CommentFromLearnerItem(ActivityAttemptId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="CommentFromLmsItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains a <a href="SlkConcepts.htm#ScormConcepts">"comments from LMS"</a> string related to a
specific <a href="SlkConcepts.htm#Packages">activity</a> within an e-learning package.
These are read-only by <a href="SlkConcepts.htm#Packages">SCOs</a>. SLK does not add
rows to the CommentsFromLmsItem table.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="ActivityPackageId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>ActivityPackageId is the identifier of the activity in a specific package associated with this comment.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Comment" Type="String" Length="4096">
<Documentation>
<Summary xmlns="">
<para>Comment is the text of the comment.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Location" Type="String" Length="255" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>Location is the text indicating where the comment applies.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Timestamp" Type="String" Length="28" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>Timestamp is the timestamp (UTC) indicating when comment was created or most recently changed.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX ActivityPackageIndex
ON CommentFromLmsItem(ActivityPackageId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="CorrectResponseItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about one SCORM <a href="SlkConcepts.htm#ScormConcepts">correct response string</a>
for one <a href="Microsoft.LearningComponents.Storage.BaseSchema.InteractionItem.Class.htm">InteractionItem</a>.
The CorrectResponseItem table contains one row in this table per correct response per
interaction.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>InteractionId is the identifier of the interaction for which this is a correct response.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ResponsePattern" Type="String">
<Documentation>
<Summary xmlns="">
<para>ResponsePattern is the pattern of the correct response.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX InteractionIndex
ON CorrectResponseItem(InteractionId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="EvaluationCommentItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains a comment from an evaluator (i.e. an instructor grading a
<a href="SlkConcepts.htm#Assignments">learner assignment</a>) related to one
<a href="Microsoft.LearningComponents.Storage.BaseSchema.InteractionItem.Class.htm">InteractionItem</a>. Only used for e-learning packages in Class Server format.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>InteractionId is the identifier of the interaction for which this is a comment.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Comment" Type="String" Length="4096">
<Documentation>
<Summary xmlns="">
<para>Comment is the text of the comment.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Location" Type="String" Length="255" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>Location is the text indicating where the comment applies.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Ordinal" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>Ordinal is the identifier for the comment that is unique within the interaction.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Timestamp" Type="String" Length="28" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>Timestamp is the timestamp (UTC) indicating when comment was created or most recently changed.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX EvaluationCommentIndex
ON EvaluationCommentItem(InteractionId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="ExtensionDataItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains one "extension" <a href="MlcDataModel.htm">data model element</a>. An "extension" data
model element is a data model element whose name does not begin with "cmi." or "adl.".</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="ActivityAttemptId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" Nullable="true" CascadeDelete="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ActivityAttemptId is the identifier of the attempt activity associated with this element.</para>
</Summary>
</Documentation>
</Property>
<Property Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>InteractionId is the TODO.</para>
</Summary>
</Documentation>
</Property>
<Property Name="AttemptObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptObjectiveItem" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>If this data is related to an objective, AttemptObjectiveId is the related identifier.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Name" Type="String" Length="256" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Name is the key of the element.</para>
</Summary>
</Documentation>
</Property>
<Property Name="AttachmentGuid" Type="Guid" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>AttachmentGuid is the value of an element represented by a GUID (globally unique identifier).</para>
</Summary>
</Documentation>
</Property>
<Property Name="AttachmentValue" Type="ByteArray" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>AttachmentValue is the value of the element represented as an array of bytes.</para>
</Summary>
</Documentation>
</Property>
<Property Name="BoolValue" Type="Boolean" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>BoolValue is the value of the element represented as a Boolean.</para>
</Summary>
</Documentation>
</Property>
<Property Name="DateTimeValue" Type="DateTime" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>DateTimeValue is the value of the element represented as a DateTime. The value should be UTC.</para>
</Summary>
</Documentation>
</Property>
<Property Name="DoubleValue" Type="Double" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>DoubleValue is the value of the element represented as a Double.</para>
</Summary>
</Documentation>
</Property>
<Property Name="IntValue" Type="Int32" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>IntValue is the value of the element stored as an Int32.</para>
</Summary>
</Documentation>
</Property>
<Property Name="StringValue" Type="String" Nullable="true" Length="4096">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>StringValue is the value of the element stored as a string.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX ActivityAttemptIndex
ON ExtensionDataItem(ActivityAttemptId, AttachmentGuid, InteractionId, AttemptObjectiveId)
</Index>
<Index>
CREATE INDEX AttachmentGuidIndex
ON ExtensionDataItem(AttachmentGuid, AttemptObjectiveId)
</Index>
<Index>
CREATE INDEX InteractionAndObjectiveIndex
ON ExtensionDataItem(InteractionId, AttemptObjectiveId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="GlobalObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about one
<a href="SlkConcepts.htm#ScormConcepts">global objective</a> related to one
<a href="SlkConcepts.htm#Packages">organization</a> of one e-learning package, or one
global objective that's not constrained to any one organization of any package.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="OrganizationId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" Nullable="true" CascadeDelete="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>OrganizationId is the organization which contains a reference to this objective. If null, the objective applies to entire system.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Key" Type="String" Length="4096">
<Documentation>
<Summary xmlns="">
<para>Key is an identifier for the global objective. If PackageId is null, this is unique within the table, otherwise, it is unique within the package.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Description" Type="String" Nullable="true" Length="4096">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Description is the text description of the objective.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX OrganizationIndex
ON GlobalObjectiveItem(OrganizationId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="InteractionItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about one <a href="SlkConcepts.htm#ScormConcepts">interaction</a> within
one <a href="SlkConcepts.htm#Packages">activity</a> of one
<a href="SlkConcepts.htm#Assignments">attempt</a>.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="ActivityAttemptId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>ActivityAttemptId is the identifier for the activity that contains this interaction.</para>
</Summary>
</Documentation>
</Property>
<Property Name="InteractionIdFromCmi" Type="String" Length="4096">
<Documentation>
<Summary xmlns="">
<para>InteractionIdFromCmi is the identifier that is provided by the SCO, through the cmi.interactions.n.id value.</para>
</Summary>
</Documentation>
</Property>
<Property Name="InteractionType" Type="Enum" EnumName="InteractionType" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>InteractionType is the type of interaction (for example, true-false).</para>
</Summary>
</Documentation>
</Property>
<Property Name="Timestamp" Type="String" Length="28" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Timestamp is the point in time (UTC) when the interaction was first made available to the learner.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Weighting" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Weighting is the weight given to the interaction. This is commonly used for calculating the score on the activity.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ResultState" Type="Enum" EnumName="InteractionResultState" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ResultState is an analysis of the result of the interaction; for example, "correct".</para>
</Summary>
</Documentation>
</Property>
<Property Name="ResultNumeric" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ResultNumeric is the numeric value of the interaction result.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Latency" Type="Double" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Latency is the duration of time between the first interaction and the first response.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Description" Type="String" Length="255" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Description is a brief description of the interaction.</para>
</Summary>
</Documentation>
</Property>
<Property Name="LearnerResponseBool" Type="Boolean" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>LearnerResponseBool is the response from the user to a true-false question.</para>
</Summary>
</Documentation>
</Property>
<Property Name="LearnerResponseString" Type="String" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>LearnerResponseString is the response from the user to a sequencing, multiple choice or likert question.</para>
</Summary>
</Documentation>
</Property>
<Property Name="LearnerResponseNumeric" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>LearnerResponseNumeric is the response from the user to a numeric question.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ScaledScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ScaledScore is the score that reflects the performance of the learner.</para>
</Summary>
</Documentation>
</Property>
<Property Name="RawScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>RawScore is the score that reflects the performance of the learner, between MinScore and MinScore.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MinScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>MinScore is the minimum score allowed.</para>
</Summary>
</Documentation>
</Property>
<Property Name="MaxScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>MaxScore is the maximum score allowed.</para>
</Summary>
</Documentation>
</Property>
<Property Name="EvaluationPoints" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>EvaluationPoints is the point value assigned to the interaction within the context of the Evaluation.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX ActivityAttemptIndex
ON InteractionItem(ActivityAttemptId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="InteractionObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>Each item relates one
<a href="Microsoft.LearningComponents.Storage.BaseSchema.InteractionItem.Class.htm">InteractionItem</a> with one
<a href="Microsoft.LearningComponents.Storage.BaseSchema.AttemptObjectiveItem.Class.htm">AttemptObjectiveItem</a>.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>InteractionId is the identifier of the interaction for this mapping.</para>
</Summary>
</Documentation>
</Property>
<Property Name="AttemptObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>AttemptObjectiveId is the identifier of the AttemptObjectiveItem related to this objective.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX InteractionIndex
ON InteractionObjectiveItem(InteractionId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="LearnerGlobalObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about the progress of one learner against a particular
global objective, across all <a href="SlkConcepts.htm#Packages">activities</a> in all
e-learning packages. These objectives may be global to a single package or global to
the system -- the data in this table does not distinguish between these two
cases.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>LearnerId is the identifier of the learner.</para>
</Summary>
</Documentation>
</Property>
<Property Name="GlobalObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="GlobalObjectiveItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>GlobalObjectiveId is the identifier of the objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ScaledScore" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>ScaledScore is the measure of result (i.e, a score) for the objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>SuccessStatus indicates whether the objective has been satisfied.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX LearnerIndex
ON LearnerGlobalObjectiveItem(LearnerId, GlobalObjectiveId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="MapActivityObjectiveToGlobalObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains a mapping between an
<a href="Microsoft.LearningComponents.Storage.BaseSchema.ActivityObjectiveItem.Class.htm">ActivityObjectiveItem</a> and a
<a href="Microsoft.LearningComponents.Storage.BaseSchema.GlobalObjectiveItem.Class.htm">GlobalObjectiveItem</a>.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="ActivityObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityObjectiveItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>ActivityObjectiveId is the identifier for the activity objective being mapped to a global objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="GlobalObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="GlobalObjectiveItem">
<Documentation>
<Summary xmlns="">
<para>GlobalObjectiveId is the identifier for the global objective being mapped to a local (activity) objective.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ReadSatisfiedStatus" Type="Boolean">
<Default>true</Default>
<Documentation>
<Summary xmlns="">
<para>ReadSatisfiedStatus indicates that the satisfaction status for the identified local objective should be retrieved from the identified shared global objective when the progress for this objective is undefined.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ReadNormalizedMeasure" Type="Boolean">
<Default>true</Default>
<Documentation>
<Summary xmlns="">
<para>ReadNormalizedMeasure is indicates that the normalized measure for the identified local objective should be retrieved from the identified shared global objective when the measure for this objective is undefined.</para>
</Summary>
</Documentation>
</Property>
<Property Name="WriteSatisfiedStatus" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>WriteSatisfiedStatus indicates that the normalized measure for the this objective should be retrieved from the identified shared global objective when the measure for the this objective is undefined.</para>
</Summary>
</Documentation>
</Property>
<Property Name="WriteNormalizedMeasure" Type="Boolean">
<Default>false</Default>
<Documentation>
<Summary xmlns="">
<para>WriteNormalizedMeasure indicates that the normalized measure for the identified local objective should be transferred to the identified shared global objective upon termination of the attempt on the activity.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX GlobalObjectiveIndex
ON MapActivityObjectiveToGlobalObjectiveItem(GlobalObjectiveId, ActivityObjectiveId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="PackageItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about one <a href="SlkConcepts.htm#Packages">e-learning
package</a>. Before a package can be
<a href="SlkConcepts.htm#Assignments">attempted</a>, a row referring to it must be
added to this table. When that happens, detailed information about the package is
added to other tables in the schema; for example, information about each
<a href="SlkConcepts.htm#Packages">activity</a> is added to the ActivityPackageItem
table. SLK <a href="SlkSchema.xml.htm">extends</a> this item type by adding the <a href="Microsoft.SharePointLearningKit.Schema.PackageItem.Warnings.Field.htm">Warnings</a> property/column.
</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="PackageFormat" Type="Enum" EnumName="PackageFormat">
<Documentation>
<Summary xmlns="">
<para>PackageFormat is the type of content in the package: SCORM 2004, SCORM 1.2, or Class Server format.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Location" Type="String" Length="260">
<Documentation>
<Summary xmlns="">
<para>Location is the location of the files within the package. The format of this field is determined by the application.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Manifest" Type="Xml">
<Documentation>
<Summary xmlns="">
<para>Manifest is the imsmanifest.xml of the package.</para>
</Summary>
</Documentation>
</Property>
</Properties>
</ItemType>
<ItemType Name="RubricItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about a rubric that is attached to an
<a href="SlkConcepts.htm#ScormConcepts">interaction</a>.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>InteractionId is the identifier of the interaction that owns this rubric.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Ordinal" Type="Int32">
<Documentation>
<Summary xmlns="">
<para>Ordinal is the identifier of the rubric. Unique within an interaction.</para>
</Summary>
</Documentation>
</Property>
<Property Name="IsSatisfied" Type="Boolean" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>IsSatisfied indicates if the user has satisfied this rubric.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Points" Type="Single" Nullable="true">
<Default Null="true" />
<Documentation>
<Summary xmlns="">
<para>Points is the point value allowed for this rubric.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX InteractionIndex
ON RubricItem(InteractionId)
</Index>
</Indexes>
</ItemType>
<ItemType Name="ResourceItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about <a href="SlkConcepts.htm#ScormConcepts">resources</a> used in
activities, including the XML of each <tt><resource></tt> element in the
package.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>PackageId is the identifier of the package that contains this resource.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ResourceXml" Type="Xml">
<Documentation>
<Summary xmlns="">
<para>ResourceXml is the <resources> node from the package corresponding to these resources.</para>
</Summary>
</Documentation>
</Property>
</Properties>
</ItemType>
<ItemType Name="SequencingLogEntryItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains one sequencing log entry, related to one
<a href="SlkConcepts.htm#Packages">activity</a> of one
<a href="SlkConcepts.htm#Assignments">attempt</a>, or related to an entire
<a href="SlkConcepts.htm#Assignments">attempt</a>.
See <a href="Microsoft.LearningComponents.Storage.StoredLearningSession.LoggingOptions.Property.htm">StoredLearningSession.LoggingOptions</a>.</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> Access is granted to no users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" CascadeDelete="true">
<Documentation>
<Summary xmlns="">
<para>AttemptId is the identifier for the attempt to which the log entry applies.</para>
</Summary>
</Documentation>
</Property>
<Property Name="ActivityAttemptId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" Nullable="true">
<Documentation>
<Summary xmlns="">
<para>ActivityAttemptId is the identifier of the activity that is active after this log entry was created.</para>
</Summary>
</Documentation>
</Property>
<Property Name="EventType" Type="Enum" EnumName="SequencingEventType">
<Documentation>
<Summary xmlns="">
<para>EventType is the type of event that caused this entry.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Message" Type="String">
<Documentation>
<Summary xmlns="">
<para>Message is the description that includes why the event happened.</para>
</Summary>
</Documentation>
</Property>
<Property Name="NavigationCommand" Type="Enum" EnumName="NavigationCommand">
<Documentation>
<Summary xmlns="">
<para>NavigationCommand is the navigation command that caused this event.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Timestamp" Type="DateTime">
<Documentation>
<Summary xmlns="">
<para>Timestamp is the time (UTC) at which the log entry was created.</para>
</Summary>
</Documentation>
</Property>
</Properties>
</ItemType>
<ItemType Name="UserItem">
<Documentation>
<Summary xmlns="">
<para>Each item contains information about one user, including a numeric identifier
(<a href="Microsoft.LearningComponents.Storage.UserItemIdentifier.Class.htm">UserItemIdentifier</a>)
used elsewhere in the database to refer to the user. UserItem items contain a
<a href="Microsoft.LearningComponents.Storage.BaseSchema.UserItem.Key.Field.htm">Key</a>
property (database column) which, for SLK, contains either the security ID (SID) of the
user or the user's login name. (The login name is used for authentication mechanisms
such as forms-based authentication which don't use security IDs.)</para>
<para>This <a href="SlkSchema.htm">LearningStore item type</a> is available in both <a href="Default.htm">SLK</a> and <a href="Mlc.htm">MLC</a>. SLK <a href="SlkSchema.xml.htm">extends</a> this item type by granting access to all users.</para>
</Summary>
<Remarks xmlns="">
<para>
<b><a href="SlkSchema.htm">Default operation-level security</a>:</b> In MLC, access is granted to no users. In SLK, query access only is granted to all users.</para>
<para>In MLC, this item type is defined in the namespace Microsoft.LearningComponents.Storage.BaseSchema, in the assembly Microsoft.LearningComponents.Storage.dll.</para>
</Remarks>
</Documentation>
<Properties>
<Property Name="Key" Type="String" Length="250">
<Documentation>
<Summary xmlns="">
<para>Key is a string that uniquely identifies this user. The format of the key is defined by the application. For example, SLK uses a security ID (SID) if available, or a login name for authentication mechanisms (such as forms-based authentication) that don't support SIDs.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Name" Type="String" Length="255">
<Documentation>
<Summary xmlns="">
<para>Name is the "friendly name" of the learner -- typically first and last name.</para>
</Summary>
</Documentation>
</Property>
<Property Name="AudioCaptioning" Type="Enum" EnumName="AudioCaptioning">
<Default>0</Default>
<Documentation>
<Summary xmlns="">
<para>AudioCaptioning specifies whether audio captioning is enabled for this user.</para>
</Summary>
</Documentation>
</Property>
<Property Name="AudioLevel" Type="Single">
<Default>1</Default>
<Documentation>
<Summary xmlns="">
<para>AudioLevel is the user's preferred audio listening level.</para>
</Summary>
</Documentation>
</Property>
<Property Name="DeliverySpeed" Type="Single">
<Default>1</Default>
<Documentation>
<Summary xmlns="">
<para>DeliverySpeed is a scale for how fast content is delivered.</para>
</Summary>
</Documentation>
</Property>
<Property Name="Language" Type="String" Length="255">
<Default />
<Documentation>
<Summary xmlns="">
<para>Language is the preferred language of the user.</para>
</Summary>
</Documentation>
</Property>
</Properties>
<Indexes>
<Index>
CREATE INDEX KeyIndex
ON UserItem([Key])
</Index>
</Indexes>
</ItemType>
<View Name="SeqNavOrganizationGlobalObjectiveView">
<Columns>
<Column Name="OrganizationId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="Key" Type="String" />
<Column Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem" />
<Column Name="ScaledScore" Type="Single" />
<Column Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus" />
</Columns>
<Implementation>
SELECT GlobalObjectiveItem.OrganizationId OrganizationId, GlobalObjectiveItem.[Key] [Key], PackageGlobalObjectiveItem.LearnerId LearnerId, PackageGlobalObjectiveItem.ScaledScore ScaledScore, PackageGlobalObjectiveItem.SuccessStatus SuccessStatus
FROM GlobalObjectiveItem
INNER JOIN PackageGlobalObjectiveItem ON PackageGlobalObjectiveItem.GlobalObjectiveId=GlobalObjectiveItem.Id
</Implementation>
</View>
<View Name="SeqNavLearnerGlobalObjectiveView">
<Columns>
<Column Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem" />
<Column Name="Key" Type="String" />
<Column Name="ScaledScore" Type="Single" />
<Column Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus" />
</Columns>
<Implementation>
SELECT LearnerGlobalObjectiveItem.LearnerId LearnerId, GlobalObjectiveItem.[Key] [Key], LearnerGlobalObjectiveItem.ScaledScore ScaledScore, LearnerGlobalObjectiveItem.SuccessStatus SuccessStatus
FROM GlobalObjectiveItem
INNER JOIN LearnerGlobalObjectiveItem ON LearnerGlobalObjectiveItem.GlobalObjectiveId=GlobalObjectiveItem.Id
</Implementation>
</View>
<View Name="SeqNavActivityPackageView">
<Columns>
<Column Name="Id" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem" />
<Column Name="PackageFormat" Type="Enum" EnumName="PackageFormat" />
<Column Name="PackagePath" Type="String" />
</Columns>
<Implementation>
SELECT ActivityPackageItem.Id, ActivityPackageItem.PackageId,PackageItem.PackageFormat PackageFormat, PackageItem.Location PackagePath
FROM ActivityPackageItem
INNER JOIN PackageItem ON ActivityPackageItem.PackageId=PackageItem.Id
</Implementation>
</View>
<View Name="SeqNavActivityTreeView">
<Columns>
<Column Name="Id" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="ParentActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="DataModelCache" Type="Xml" />
<Column Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="ObjectivesGlobalToSystem" Type="Boolean" />
</Columns>
<Implementation>
WITH TreeQuery(Id, ParentActivityId, DataModelCache, RootActivityId, ObjectivesGlobalToSystem)
AS (
SELECT Id, ParentActivityId, DataModelCache, Id, ObjectivesGlobalToSystem
FROM ActivityPackageItem
UNION ALL
SELECT t1.Id, t1.ParentActivityId, t1.DataModelCache, t2.RootActivityId, t1.ObjectivesGlobalToSystem
FROM TreeQuery t2
INNER JOIN ActivityPackageItem t1 ON t1.ParentActivityId=t2.Id )
SELECT Id, ParentActivityId, DataModelCache, RootActivityId, ObjectivesGlobalToSystem
FROM TreeQuery
</Implementation>
</View>
<View Name="SeqNavAttemptView">
<Columns>
<Column Name="Id" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="AttemptStatus" Type="Enum" EnumName="AttemptStatus" />
<Column Name="LogDetailSequencing" Type="Boolean" />
<Column Name="LogFinalSequencing" Type="Boolean" />
<Column Name="LogRollup" Type="Boolean" />
<Column Name="CurrentActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="SuspendedActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem" />
<Column Name="PackageFormat" Type="Enum" EnumName="PackageFormat" />
<Column Name="PackagePath" Type="String" />
<Column Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem" />
<Column Name="LearnerName" Type="String" />
<Column Name="LearnerAudioCaptioning" Type="Enum" EnumName="AudioCaptioning" />
<Column Name="LearnerAudioLevel" Type="Single" />
<Column Name="LearnerDeliverySpeed" Type="Single" />
<Column Name="LearnerLanguage" Type="String" />
<Column Name="StartedTimestamp" Type="DateTime" />
<Column Name="FinishedTimestamp" Type="DateTime" />
<Column Name="TotalPoints" Type="Single" />
<Column Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus" />
<Column Name="CompletionStatus" Type="Enum" EnumName="CompletionStatus" />
</Columns>
<Implementation>
SELECT AttemptItem.Id Id, AttemptItem.AttemptStatus, AttemptItem.LogDetailSequencing, AttemptItem.LogFinalSequencing, AttemptItem.LogRollup, AttemptItem.CurrentActivityId, AttemptItem.SuspendedActivityId, AttemptItem.RootActivityId,AttemptItem.StartedTimestamp, AttemptItem.FinishedTimestamp,PackageItem.Id PackageId, PackageItem.PackageFormat PackageFormat, PackageItem.Location PackagePath, UserItem.Id LearnerId, UserItem.Name LearnerName, UserItem.AudioCaptioning LearnerAudioCaptioning, UserItem.AudioLevel LearnerAudioLevel, UserItem.DeliverySpeed LearnerDeliverySpeed, UserItem.Language LearnerLanguage, AttemptItem.TotalPoints, AttemptItem.SuccessStatus, AttemptItem.CompletionStatus
FROM AttemptItem
INNER JOIN PackageItem ON AttemptItem.PackageId=PackageItem.Id
INNER JOIN UserItem ON AttemptItem.LearnerId=UserItem.Id
</Implementation>
</View>
<View Name="SeqNavActivityAttemptView">
<Columns>
<Column Name="Id" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" />
<Column Name="DataModelCache" Type="Xml" />
<Column Name="SequencingDataCache" Type="Xml" />
<Column Name="RandomPlacement" Type="Int32" />
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="ActivityPackageId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="StaticDataModelCache" Type="Xml" />
<Column Name="ParentId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Column Name="ObjectivesGlobalToSystem" Type="Boolean" />
<Column Name="CompletionStatus" Type="Enum" EnumName="CompletionStatus" />
<Column Name="AttemptCount" Type="Int32" />
<Column Name="EvaluationPoints" Type="Single" />
<Column Name="Exit" Type="Enum" EnumName="ExitMode" />
<Column Name="LessonStatus" Type="Enum" EnumName="LessonStatus" />
<Column Name="Location" Type="String" />
<Column Name="MinScore" Type="Single" />
<Column Name="MaxScore" Type="Single" />
<Column Name="ProgressMeasure" Type="Single" />
<Column Name="RawScore" Type="Single" />
<Column Name="ScaledScore" Type="Single" />
<Column Name="SessionStartTimestamp" Type="DateTime" />
<Column Name="SessionTime" Type="Double" />
<Column Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus" />
<Column Name="SuspendData" Type="String" />
<Column Name="TotalTime" Type="Double" />
</Columns>
<Implementation>
SELECT ActivityAttemptItem.Id, ActivityAttemptItem.DataModelCache, ActivityAttemptItem.SequencingDataCache, ActivityAttemptItem.RandomPlacement, ActivityAttemptItem.AttemptId, ActivityAttemptItem.ActivityPackageId, ActivityPackageItem.DataModelCache StaticDataModelCache, ActivityPackageItem.ParentActivityId ParentId, ActivityPackageItem.ObjectivesGlobalToSystem ObjectivesGlobalToSystem, ActivityAttemptItem.CompletionStatus, ActivityAttemptItem.AttemptCount, ActivityAttemptItem.EvaluationPoints, ActivityAttemptItem.[Exit], ActivityAttemptItem.LessonStatus, ActivityAttemptItem.Location, ActivityAttemptItem.MinScore, ActivityAttemptItem.MaxScore, ActivityAttemptItem.ProgressMeasure, ActivityAttemptItem.RawScore, ActivityAttemptItem.ScaledScore, ActivityAttemptItem.SessionStartTimestamp, ActivityAttemptItem.SessionTime, ActivityAttemptItem.SuccessStatus, ActivityAttemptItem.SuspendData, ActivityAttemptItem.TotalTime
FROM ActivityAttemptItem
INNER JOIN ActivityPackageItem ON ActivityAttemptItem.ActivityPackageId=ActivityPackageItem.Id
</Implementation>
</View>
<View Name="SeqNavCurrentActivityAttemptView">
<Columns>
<Column Name="Id" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" />
<Column Name="DataModelCache" Type="Xml" />
<Column Name="SequencingDataCache" Type="Xml" />
<Column Name="RandomPlacement" Type="Int32" />
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="StaticDataModelCache" Type="Xml" />
<Column Name="ObjectivesGlobalToSystem" Type="Boolean" />
<Column Name="Credit" Type="Boolean" />
</Columns>
<Implementation>
SELECT ActivityAttemptItem.Id, ActivityAttemptItem.DataModelCache DataModelCache, ActivityAttemptItem.SequencingDataCache, ActivityAttemptItem.RandomPlacement, ActivityAttemptItem.AttemptId, ActivityPackageItem.DataModelCache StaticDataModelCache, ActivityPackageItem.ObjectivesGlobalToSystem ObjectivesGlobalToSystem, ActivityPackageItem.Credit Credit
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN ActivityPackageItem ON ActivityAttemptItem.ActivityPackageId=ActivityPackageItem.Id
WHERE AttemptItem.CurrentActivityId=ActivityPackageItem.Id
</Implementation>
</View>
<View Name="SeqNavCurrentCommentFromLmsView">
<Columns>
<Column Name="Comment" Type="String" />
<Column Name="Location" Type="String" />
<Column Name="Timestamp" Type="DateTime" />
<Column Name="DataModelCache" Type="Xml" />
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
</Columns>
<Implementation>
SELECT CommentFromLmsItem.Comment, CommentFromLmsItem.Location, CommentFromLmsItem.Timestamp, AttemptItem.Id AttemptId, ActivityAttemptItem.DataModelCache
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN ActivityPackageItem ON ActivityAttemptItem.ActivityPackageId=ActivityPackageItem.Id
INNER JOIN CommentFromLmsItem ON ActivityPackageItem.Id=CommentFromLmsItem.ActivityPackageId
WHERE AttemptItem.CurrentActivityId=ActivityPackageItem.Id
</Implementation>
</View>
<View Name="SeqNavAttemptObjectiveView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="AttemptObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptObjectiveItem" />
<Column Name="ActivityAttemptId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" />
<Column Name="CompletionStatus" Type="Enum" EnumName="CompletionStatus" />
<Column Name="Description" Type="String" />
<Column Name="IsPrimaryObjective" Type="Boolean" />
<Column Name="Key" Type="String" />
<Column Name="LessonStatus" Type="Enum" EnumName="LessonStatus" />
<Column Name="RawScore" Type="Single" />
<Column Name="MinScore" Type="Single" />
<Column Name="MaxScore" Type="Single" />
<Column Name="ProgressMeasure" Type="Single" />
<Column Name="ScaledScore" Type="Single" />
<Column Name="SuccessStatus" Type="Enum" EnumName="SuccessStatus" />
</Columns>
<Implementation>
SELECT AttemptObjectiveItem.Id AttemptObjectiveId, AttemptItem.Id AttemptId, AttemptObjectiveItem.CompletionStatus, AttemptObjectiveItem.Description, AttemptObjectiveItem.[Key], AttemptObjectiveItem.LessonStatus, AttemptObjectiveItem.RawScore, AttemptObjectiveItem.MinScore, AttemptObjectiveItem.MaxScore, AttemptObjectiveItem.ProgressMeasure, AttemptObjectiveItem.ScaledScore, AttemptObjectiveItem.SuccessStatus, AttemptObjectiveItem.ActivityAttemptId, AttemptObjectiveItem.IsPrimaryObjective
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN AttemptObjectiveItem ON AttemptObjectiveItem.ActivityAttemptId=ActivityAttemptItem.Id
</Implementation>
</View>
<View Name="SeqNavAttemptCommentFromLearnerView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="ActivityAttemptId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" />
<Column Name="CommentFromLearnerId" Type="ItemIdentifier" ReferencedItemTypeName="CommentFromLearnerItem" />
<Column Name="Comment" Type="String" />
<Column Name="Location" Type="String" />
<Column Name="Timestamp" Type="String" />
<Column Name="Ordinal" Type="Int32" />
</Columns>
<Implementation>
SELECT CommentFromLearnerItem.Id CommentFromLearnerId, AttemptItem.Id AttemptId, CommentFromLearnerItem.Comment, CommentFromLearnerItem.Location, CommentFromLearnerItem.Timestamp, CommentFromLearnerItem.ActivityAttemptId, CommentFromLearnerItem.Ordinal
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN CommentFromLearnerItem ON CommentFromLearnerItem.ActivityAttemptId=ActivityAttemptItem.Id
</Implementation>
</View>
<View Name="SeqNavAttemptInteractionView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="ActivityAttemptId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" />
<Column Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" />
<Column Name="InteractionIdFromCmi" Type="String" />
<Column Name="InteractionType" Type="Enum" EnumName="InteractionType" />
<Column Name="Timestamp" Type="String" />
<Column Name="Weighting" Type="Single" />
<Column Name="ResultState" Type="Enum" EnumName="InteractionResultState" />
<Column Name="ResultNumeric" Type="Single" />
<Column Name="Latency" Type="Double" />
<Column Name="Description" Type="String" />
<Column Name="LearnerResponseBool" Type="Boolean" />
<Column Name="LearnerResponseString" Type="String" />
<Column Name="LearnerResponseNumeric" Type="Single" />
<Column Name="ScaledScore" Type="Single" />
<Column Name="RawScore" Type="Single" />
<Column Name="MinScore" Type="Single" />
<Column Name="MaxScore" Type="Single" />
<Column Name="EvaluationPoints" Type="Single" />
</Columns>
<Implementation>
SELECT InteractionItem.Id InteractionId, AttemptItem.Id AttemptId, InteractionItem.InteractionIdFromCmi, InteractionItem.InteractionType, InteractionItem.Timestamp, InteractionItem.Weighting, InteractionItem.ResultState, InteractionItem.ResultNumeric, InteractionItem.Latency, InteractionItem.Description, InteractionItem.LearnerResponseBool, InteractionItem.LearnerResponseString, InteractionItem.LearnerResponseNumeric, InteractionItem.ScaledScore, InteractionItem.RawScore, InteractionItem.MinScore, InteractionItem.MaxScore, InteractionItem.ActivityAttemptId, InteractionItem.EvaluationPoints
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN InteractionItem ON InteractionItem.ActivityAttemptId=ActivityAttemptItem.Id
</Implementation>
</View>
<View Name="SeqNavAttemptEvaluationCommentLearnerView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" />
<Column Name="EvaluationCommentId" Type="ItemIdentifier" ReferencedItemTypeName="EvaluationCommentItem" />
<Column Name="Comment" Type="String" />
<Column Name="Location" Type="String" />
<Column Name="Timestamp" Type="String" />
<Column Name="Ordinal" Type="Int32" />
</Columns>
<Implementation>
SELECT EvaluationCommentItem.Id EvaluationCommentId, AttemptItem.Id AttemptId, EvaluationCommentItem.Comment, EvaluationCommentItem.Location, EvaluationCommentItem.Timestamp, EvaluationCommentItem.InteractionId, EvaluationCommentItem.Ordinal
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN InteractionItem ON InteractionItem.ActivityAttemptId=ActivityAttemptItem.Id
INNER JOIN EvaluationCommentItem ON EvaluationCommentItem.InteractionId=InteractionItem.Id
</Implementation>
</View>
<View Name="SeqNavAttemptCorrectResponseView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="CorrectResponseId" Type="ItemIdentifier" ReferencedItemTypeName="CorrectResponseItem" />
<Column Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" />
<Column Name="ResponsePattern" Type="String" />
</Columns>
<Implementation>
SELECT CorrectResponseItem.Id CorrectResponseId, AttemptItem.Id AttemptId, CorrectResponseItem.InteractionId, CorrectResponseItem.ResponsePattern
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN InteractionItem ON InteractionItem.ActivityAttemptId=ActivityAttemptItem.Id
INNER JOIN CorrectResponseItem ON CorrectResponseItem.InteractionId=InteractionItem.Id
</Implementation>
</View>
<View Name="SeqNavAttemptInteractionObjectiveView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="InteractionObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionObjectiveItem" />
<Column Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" />
<Column Name="AttemptObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptObjectiveItem" />
</Columns>
<Implementation>
SELECT InteractionObjectiveItem.Id InteractionObjectiveId, AttemptItem.Id AttemptId, InteractionObjectiveItem.AttemptObjectiveId, InteractionObjectiveItem.InteractionId
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN InteractionItem ON InteractionItem.ActivityAttemptId=ActivityAttemptItem.Id
INNER JOIN InteractionObjectiveItem ON InteractionObjectiveItem.InteractionId=InteractionItem.Id
</Implementation>
</View>
<View Name="SeqNavAttemptExtensionDataView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="ActivityAttemptId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityAttemptItem" />
<Column Name="ExtensionDataId" Type="ItemIdentifier" ReferencedItemTypeName="ExtensionDataItem" />
<Column Name="Name" Type="String" />
<Column Name="StringValue" Type="String" />
<Column Name="IntValue" Type="Int32" />
<Column Name="BoolValue" Type="Boolean" />
<Column Name="DoubleValue" Type="Double" />
<Column Name="DateTimeValue" Type="DateTime" />
<Column Name="AttachmentGuid" Type="Guid" />
</Columns>
<Implementation>
SELECT ExtensionDataItem.Id ExtensionDataId, AttemptItem.Id AttemptId, ExtensionDataItem.Name, ExtensionDataItem.StringValue, ExtensionDataItem.IntValue, ExtensionDataItem.BoolValue, ExtensionDataItem.DoubleValue, ExtensionDataItem.DateTimeValue, ExtensionDataItem.AttachmentGuid, ExtensionDataItem.ActivityAttemptId
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN ExtensionDataItem ON ExtensionDataItem.ActivityAttemptId=ActivityAttemptItem.Id
WHERE ExtensionDataItem.AttemptObjectiveId IS NULL AND
ExtensionDataItem.InteractionId IS NULL
</Implementation>
</View>
<View Name="SeqNavAttemptObjectiveExtensionDataView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="ExtensionDataId" Type="ItemIdentifier" ReferencedItemTypeName="ExtensionDataItem" />
<Column Name="AttemptObjectiveId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptObjectiveItem" />
<Column Name="Name" Type="String" />
<Column Name="StringValue" Type="String" />
<Column Name="IntValue" Type="Int32" />
<Column Name="BoolValue" Type="Boolean" />
<Column Name="DoubleValue" Type="Double" />
<Column Name="DateTimeValue" Type="DateTime" />
<Column Name="AttachmentGuid" Type="Guid" />
<Column Name="AttachmentValue" Type="ByteArray" />
</Columns>
<Implementation>
SELECT ExtensionDataItem.Id ExtensionDataId, ExtensionDataItem.AttemptObjectiveId, AttemptItem.Id AttemptId, ExtensionDataItem.Name, ExtensionDataItem.StringValue, ExtensionDataItem.IntValue, ExtensionDataItem.BoolValue, ExtensionDataItem.DoubleValue, ExtensionDataItem.DateTimeValue, ExtensionDataItem.AttachmentGuid, ExtensionDataItem.AttachmentValue
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN AttemptObjectiveItem ON AttemptObjectiveItem.ActivityAttemptId=ActivityAttemptItem.Id
INNER JOIN ExtensionDataItem ON ExtensionDataItem.AttemptObjectiveId=AttemptObjectiveItem.Id
WHERE ExtensionDataItem.InteractionId IS NULL AND
ExtensionDataItem.AttemptObjectiveId IS NOT NULL
</Implementation>
</View>
<View Name="SeqNavAttemptInteractionExtensionDataView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="ExtensionDataId" Type="ItemIdentifier" ReferencedItemTypeName="ExtensionDataItem" />
<Column Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" />
<Column Name="Name" Type="String" />
<Column Name="StringValue" Type="String" />
<Column Name="IntValue" Type="Int32" />
<Column Name="BoolValue" Type="Boolean" />
<Column Name="DoubleValue" Type="Double" />
<Column Name="DateTimeValue" Type="DateTime" />
<Column Name="AttachmentGuid" Type="Guid" />
<Column Name="AttachmentValue" Type="ByteArray" />
</Columns>
<Implementation>
SELECT ExtensionDataItem.Id ExtensionDataId, ExtensionDataItem.InteractionId, AttemptItem.Id AttemptId, ExtensionDataItem.Name, ExtensionDataItem.StringValue, ExtensionDataItem.IntValue, ExtensionDataItem.BoolValue, ExtensionDataItem.DoubleValue, ExtensionDataItem.DateTimeValue, ExtensionDataItem.AttachmentGuid, ExtensionDataItem.AttachmentValue
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN InteractionItem ON InteractionItem.ActivityAttemptId=ActivityAttemptItem.Id
INNER JOIN ExtensionDataItem ON ExtensionDataItem.InteractionId=InteractionItem.Id
WHERE ExtensionDataItem.AttemptObjectiveId IS NULL AND
ExtensionDataItem.InteractionId IS NOT NULL
</Implementation>
</View>
<View Name="SeqNavAttemptRubricView">
<Columns>
<Column Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
<Column Name="RubricItemId" Type="ItemIdentifier" ReferencedItemTypeName="RubricItem" />
<Column Name="InteractionId" Type="ItemIdentifier" ReferencedItemTypeName="InteractionItem" />
<Column Name="Ordinal" Type="Int32" />
<Column Name="IsSatisfied" Type="Boolean" />
<Column Name="Points" Type="Single" />
</Columns>
<Implementation>
SELECT RubricItem.Id RubricItemId, AttemptItem.Id AttemptId, RubricItem.InteractionId, RubricItem.Ordinal, RubricItem.IsSatisfied, RubricItem.Points
FROM AttemptItem
INNER JOIN ActivityAttemptItem ON AttemptItem.Id=ActivityAttemptItem.AttemptId
INNER JOIN InteractionItem ON InteractionItem.ActivityAttemptId=ActivityAttemptItem.Id
INNER JOIN RubricItem ON RubricItem.InteractionId=InteractionItem.Id
</Implementation>
</View>
<Right Name="AddPackageReferenceRight">
</Right>
<Right Name="RemovePackageReferenceRight">
<Parameters>
<Parameter Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem" />
</Parameters>
</Right>
<Right Name="ReadPackageRight">
<Parameters>
<Parameter Name="PackageId" Type="ItemIdentifier" ReferencedItemTypeName="PackageItem" />
</Parameters>
</Right>
<Right Name="CreateAttemptRight">
<Parameters>
<Parameter Name="RootActivityId" Type="ItemIdentifier" ReferencedItemTypeName="ActivityPackageItem" />
<Parameter Name="LearnerId" Type="ItemIdentifier" ReferencedItemTypeName="UserItem" />
</Parameters>
</Right>
<Right Name="DeleteAttemptRight">
<Parameters>
<Parameter Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
</Parameters>
</Right>
<Right Name="ExecuteSessionRight">
<Parameters>
<Parameter Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
</Parameters>
</Right>
<Right Name="ReviewSessionRight">
<Parameters>
<Parameter Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
</Parameters>
</Right>
<Right Name="RandomAccessSessionRight">
<Parameters>
<Parameter Name="AttemptId" Type="ItemIdentifier" ReferencedItemTypeName="AttemptItem" />
</Parameters>
</Right>
</StoreSchema>